PRO/SQL View Report option
Choose this option to see the information about all SQL views defined for the working database.
Note: Views of non-OpenEdge databases are treated as tables. To display information for these views, use the table reports option. See Chapter 8, "Database Menu Reference," for more information on generating a table report.
When you choose PRO/SQL
PRO/SQL View Report, the Data Dictionary alphabetically lists all the views defined for your database. Select the views for which you want information. Figure 11–13 shows the first portion of an example view report.
The View Report window contains the following fields:
- View Name
- Updatable
- Group By
- Check Option
- View Name
- Base Tables
- Where Clause
- View Def
- Can-Read
- Can-Write
- Can-Create
- Can-Delete
- Order
- View Column Name
- Base Columns
The name of the view.
Whether the view is updatable.
Whether the view is defined with a GROUP BY clause.
Whether the view is defined with a CHECK OPTION WHERE clause.
View name of the currently displayed view.
Tables from which the view gets its information.
The WHERE clause.
The SQL statement executed when defining the view.
Users who can read the rows of the view.
Users who can update records of the view.
Users who can create new records.
Users who can delete records from the view.
Order of the columns within the view.
Names of the columns that comprise the view.
Base table field names for each view column.
To send the report to a file or printer, choose Print. The Data Dictionary prompts you for the printer or filename, whether you want to append the report to an existing file, and the page length.